SIR2002                                          11:37:09  04/18/05                                           Page    1
0
1       RUN NAME        STAFF    EXPORT
2       TASK NAME       INITIALIZATION
3       NEW FILE        STAFF
4       JOURNAL         OFF
*** REMARK *** Created new database STAFF
5       CASE ID         SUBJECT  (A)
*** REMARK *** Begin case definition
6       N OF CASES      350
7       RECS PER CASE   3
8       MAX INPUT COLS  80
9       RECTYPE COLS    1
10      MAX REC TYPES   5
11      MAX REC COUNT   100
12      COMMON VARS       SUBJECT  (A,3)         / NOCHILD  (I*1)
13                      / SPSEX    (CAT,2)       /
*** REMARK *** Common variable list updated
14      DOCUMENT        This database is a study of the characteristics
15                     of those people who attend a SIR/DBMS course.
16                     It records hair and eye colour etc of them,
17                     their spouse ( if any ) and children.
18                     It's use is purely for research.
19
20      TASK NAME       RECORD 1 (PARENT  )  SCHEMA DEFINITION
*** REMARK *** Case definition complete
21
22      RECORD SCHEMA   1  PARENT
*** REMARK *** Begin record definition
*** REMARK *** Define record type 1
23      DOCUMENT
24                     This record type stores information about the
25                     attendee, dates of birth, marriage, hair and
26                     eye colour etc. If married then also stores
27                     date of marriage. Some respondents failed to
28                     provide date of marriage when divorced etc.
29
30      SEQUENCE CHECK  OFF
31      MAX REC COUNT   1
32      REC SECURITY    0  30
33      DATA LIST       (1)
34                      /1        SUBJECT         3 -     5 (A3)
35                      /1        DOBIRTH         7 -    16 (DATE'DDIMMIYYYY')
36                      /1        SEX            18         (A1)
37                      /1        ABDNGRAD       20         (A1)
38                      /1        PHCOL          22         (I1)
39                      /1        PECOL          24         (I1)
40                      /1        MSTAT          26         (A1)
41                      /1        DOMARG         28 -    37 (DATE'DDIMMIYYYY')
42      CAT VARS        SEX       ( 'M'
43                                  'F'  )/
44                      ABDNGRAD  ( 'Y'
45                                  'N'  )/
46                      MSTAT     ( 'S'
47                                  'M'
48                                  'W'
49                                  'D'
50                                  'P'  )/
51      INTEGER VARS    AGEMARG
52      COMPUTE         AGEMARG=RND((DOMARG-DOBIRTH)/365.25)
STAFF    EXPORT                                                                                               Page    2
 RECORD 1 (PARENT  )  SCHEMA DEFINITION
53      VAR RANGES      DOBIRTH   ('01 01 1910' '31 12 1986')/
54                      PHCOL     (                    1                     8)/
55                      PECOL     (                    1                     8)/
56                      AGEMARG   (                   16                    60)/
57      MISSING VALUES  SUBJECT   ( BLANK  )/
58                      DOBIRTH   ( BLANK  )/
59                      SEX       ( BLANK  )/
60                      ABDNGRAD  ( BLANK  )/
61                      PHCOL     ( BLANK  )/
62                      PECOL     ( BLANK  )/
63                      MSTAT     ( BLANK  )/
64                      DOMARG    ( BLANK  )/
65      VALUE LABELS    SEX       ('M')' Male'
66                                ('F')' Female' /
67                      ABDNGRAD  ('Y')' Yes'
68                                ('N')' No' /
69                      PHCOL     (1)' Blonde'
70                                (2)' L.Brown'
71                                (3)' D.brown'
72                                (4)' Black'
73                                (5)' Auburn'
74                                (6)' Red'
75                                (7)' Grey'
76                                (8)' Other' /
77                      PECOL     (1)' L.Blue'
78                                (2)' D.Blue'
79                                (3)' Brown'
80                                (4)' Green'
81                                (5)' Violet'
82                                (6)' Blue'
83                                (7)' Grey'
84                                (8)' Other' /
85                      MSTAT     ('S')' Single'
86                                ('M')' Married'
87                                ('W')' Widowed'
88                                ('D')' Divorced'
89                                ('P')' Separated' /
90      VAR LABELS      DOBIRTH     ' Date of Birth (Parent)'/
91                      SEX         ' Sex of Attendee ( Parent )'/
92                      ABDNGRAD    ' Aberdeen Graduate (Parent)'/
93                      PHCOL       ' Hair Colour (Parent)'/
94                      PECOL       ' Eye Colour (Parent)'/
95                      MSTAT       ' Marital Status (Parent)'/
96                      DOMARG      ' Date of Marriage (Parent)'/
97                      AGEMARG     ' Age at Marriage  (Parent)'/
98      REJECT REC IF   (DOBIRTH GT DOMARG)
99      END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 2
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
100     TASK NAME       RECORD 2 (SPOUSE  )  SCHEMA DEFINITION
101
102     RECORD SCHEMA   2  SPOUSE
*** REMARK *** Begin record definition
*** REMARK *** Define record type 2
103     DOCUMENT
STAFF    EXPORT                                                                                               Page    3
 RECORD 2 (SPOUSE  )  SCHEMA DEFINITION
104                     This record type stores similar characteristics
105                    to the parent record. The study has limitations
106                    in that it only allows the latest spouse if more
107                    than one marriage has occurred. This is to make
108                    the study simpler, but has it's limitations.
109
110     SEQUENCE CHECK  OFF
111     MAX REC COUNT   1
112     REC SECURITY    0  30
113     DATA LIST       (1)
114                     /1        SUBJECT         3 -     5 (A3)
115                     /1        SDOBIRTH        7 -    16 (DATE'DDIMMIYYYY')
116                     /1        SPSEX          18         (A1)
117                     /1        SHCOL          20         (I1)
118                     /1        SECOL          22         (I1)
119                     /1        ABDNGRDS       24         (A1)
120     CAT VARS        SPSEX     ( 'M'
121                                 'F'  )/
122                     ABDNGRDS  ( 'Y'
123                                 'N'  )/
124     VAR RANGES      SDOBIRTH  ('01 01 1910' '31 12 1983')/
125                     SHCOL     (                    1                     8)/
126                     SECOL     (                    1                     8)/
127     MISSING VALUES  SUBJECT   ( BLANK  )/
128                     SDOBIRTH  ( BLANK  )/
129                     SPSEX     ( BLANK  )/
130                     SHCOL     ( BLANK  )/
131                     SECOL     ( BLANK  )/
132                     ABDNGRDS  ( BLANK  )/
133     VALUE LABELS    SPSEX     ('M')' Male'
134                               ('F')' Female' /
135                     SHCOL     (1)' Blonde'
136                               (2)' L.Brown'
137                               (3)' D.brown'
138                               (4)' Black'
139                               (5)' Auburn'
140                               (6)' Red'
141                               (7)' Grey'
142                               (8)' Other' /
143                     SECOL     (1)' L.Blue'
144                               (2)' D.Blue'
145                               (3)' Brown'
146                               (4)' Green'
147                               (5)' Violet'
148                               (6)' Blue'
149                               (7)' Grey'
150                               (8)' Other' /
151                     ABDNGRDS  ('Y')' Yes'
152                               ('N')' No' /
153     VAR LABELS      SDOBIRTH    ' Date of Birth (Spouse)'/
154                     SPSEX       ' Sex (Spouse)'/
155                     SHCOL       ' Hair Colour (Spouse)'/
156                     SECOL       ' Eye Colour (Spouse)'/
157                     ABDNGRDS    ' Aberdeen Graduate (Spouse)'/
158     END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 3
STAFF    EXPORT                                                                                               Page    4
 RECORD 2 (SPOUSE  )  SCHEMA DEFINITION
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
159     TASK NAME       RECORD 3 (CHILD   )  SCHEMA DEFINITION
160
161     RECORD SCHEMA   3  CHILD
*** REMARK *** Begin record definition
*** REMARK *** Define record type 3
162     DOCUMENT
163                     This record stores information on each child
164                    the characteristics stored are similar to the
165                    two parent records with instead of whether
166                    they are an Aberdeen Graduate, which type
167                    of education currently being followed.
168
169     KEY FIELDS      CNUM (A)
170     SEQUENCE CHECK  OFF
171     MAX REC COUNT   5
172     REC SECURITY    0  30
173     DATA LIST       (1)
174                     /1        SUBJECT         3 -     5 (A3)
175                     /1        CNUM            7         (I1)
176                     /1        CDOBIRTH        9 -    18 (DATE'DDIMMIYYYY')
177                     /1        CSEX           20         (A1)
178                     /1        CHCOL          22         (I1)
179                     /1        CECOL          24         (I1)
180                     /1        STATUS         26         (A1)
181                     /1        EYEAR          28         (I1)
182     CAT VARS        CSEX      ( 'M'
183                                 'F'  )/
184                     STATUS    ( 'B'
185                                 'P'
186                                 'S'
187                                 'U'
188                                 'W'  )/
189     VAR RANGES      CHCOL     (                    1                     8)/
190                     CECOL     (                    1                     8)/
191                     EYEAR     (                    1                     7)/
192     MISSING VALUES  SUBJECT   ( BLANK  )/
193                     CNUM      ( BLANK  )/
194                     CDOBIRTH  ( BLANK  )/
195                     CSEX      ( BLANK  )/
196                     CHCOL     ( BLANK  )/
197                     CECOL     ( BLANK  )/
198                     STATUS    ( BLANK  )/
199                     EYEAR     ( BLANK  )/
200     VALUE LABELS    CSEX      ('M')' Male'
201                               ('F')' Female' /
202                     CHCOL     (1)' Blonde'
203                               (2)' L.Brown'
204                               (3)' D.brown'
205                               (4)' Black'
206                               (5)' Auburn'
207                               (6)' Red'
208                               (7)' Grey'
209                               (8)' Other' /
210                     CECOL     (1)' L.Blue'
211                               (2)' D.Blue'
STAFF    EXPORT                                                                                               Page    5
 RECORD 3 (CHILD   )  SCHEMA DEFINITION
212                               (3)' Brown'
213                               (4)' Green'
214                               (5)' Violet'
215                               (6)' Blue'
216                               (7)' Grey'
217                               (8)' Other' /
218                     STATUS    ('B')' Baby'
219                               ('P')' Primary'
220                               ('S')' Secondary'
221                               ('U')' University or College'
222                               ('W')' Work' /
223     VAR LABELS      CNUM        ' Child Number'/
224                     CDOBIRTH    ' Date of Birth (Child)'/
225                     CSEX        ' Sex (Child)'/
226                     CHCOL       ' Hair Colour (Child)'/
227                     CECOL       ' Eye Colour (Child)'/
228                     STATUS      ' Educational Status (Child)'/
229                     EYEAR       ' Educational Year (Child)'/
230     REJECT REC IF   ((STATUS EQ 1 OR STATUS EQ 5)AND EYEAR GT 0)
231     END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 4
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
232     STRING LENGTH   20
233     TASK NAME       IMPORT
234     IMPORT          582
STAFF    EXPORT                                                                                               Page    6
 IMPORT
*** REMARK *** Start import
*** REMARK *** Import successfully completed
*** REMARK *** Imported cases   206
*** REMARK *** Imported records 582
234
